Adding the Summary Band

A Summary Band which will now be created will contain the employee count and sum of salaries for all departments. Recall that the Summary Band always prints on the last page, immediately before the Page Footer Band.

To create the summary band:

  1. Click on the “Create a new band” icon Create new band icon on the Band Report Editor toolbar, then click anywhere within the report image.
  2. In the dialog box that appears For the Type, select “Summary”.
  3. A frame will be placed around the band. Check the Top, Bottom, Left, and Right check boxes. Set the line width to 2.
    Edit dialog where the Summary band is selected from the list of bands.
  4. Click OK to return to the report designer. Notice the new Summary Band at the bottom of the report with the solid line surrounding the band.
    This image shows the report design at this stage including the summary band.
  5. Add the employee count and sum of salaries to the Summary Band by copying the expressions from the Group Header Band and pasting them into the Summary Band.

The final page of the report will now appear as follows:

This image shows the report at this stage with the summary band containing the number of employees and sum of sales.

Note the total employee count and sum of salaries as well as the frame around the Summary Band. The final report now appears as shown below:

This image shows the completed report grouped by Deparment. The band containing the department name is red, and the band containing the column headers is blue.

The report above consists of only one page because in the parameter query for this particular figure, only the HR and Product Development Departments were selected. There are seven departments within the sample database that could have been chosen for this report.

Additional Group Bands

This example utilizes a single Group Band to group employees by department name. If desired, additional Group Bands could be created to group, for example, by Region. Thus, nesting of Group Bands provides multi-levels of grouping.

When creating an additional Group Band, if Argos does not place the band in the desired order, you can drag the band to the correct location. Argos will always place the new group band immediately in front of the detail band.

It is recommended that the outermost group be created first, followed by inner groups. Using this method generally does not require that group bands be moved.

Not all bands are movable due to the nature of the various band types. For example the Summary Band always exists at the bottom of the report and cannot be moved.